Marking Scheme[Total: 10 Marks] |
|||||||||
Task |
Description |
Mark |
|||||||
1 |
Correct Dim statements |
1 |
|||||||
2 |
Create command buttons to access the two tasks |
1 |
|||||||
3 |
Create a new worksheet called Recording Formulas and add it to the end of the list of Worksheets |
1 |
|||||||
4 |
Find
the formulas and record the information. |
2 |
|||||||
5 |
Loop through only those cells that are used (i.e. have data in them): |
1 |
|||||||
6 |
Indentify and process only cells that have a formula |
1 |
|||||||
7 |
Record
name of worksheet from where the formula came from |
1 |
|||||||
8 |
Widen the columns if necessary: |
1 |
|||||||
9 |
Write a subroutine to delete the new sheet: |
1 |
|||||||
|
======= |
||||||||
Total |
10 |